You are here: Revised Table Definitions > FO_External_Form_Definitions

FO_External_Form_Definition

 

Not required maintenance but is needed for embedding external reports using Microsoft SQL server reporting URL based pointers. (The external URLs made using SSRS reporting function.)

Use table name in SQL statements as FO_External_Form_Definition

 

Field

Type

Notes

ExternalForms_ID

bigint

ID field, a counter. Unique

ExternalFormCode

varchar(50)

Code to identify a single report.

Enter a unique string as the code.

Description

varchar(255)

Enter a description for the report.

ReportURL

varchar(800)

URL that launches the report in the SSRS server.

Enter a valid URL.

ReportType

varchar(50)

Code for the report type.

Enter a string to identify the type. This code may be used as the type for other reports also.

CreateDate

datetime

Date record was created. Informational

EditDate

datetime

Date record was edited. Informational

CreateUser

varchar(50)

User who created the record. Informational

EditUser

varchar(50)

User who edited the record. Informational

FPModule

varchar(50)

Swaps the default Rhodesformat for the SSRS form defined.

Enter a valid FPModule code to enable.

Valid FPModule Code:

BATCHPROCESS

PermGroups

varchar(1000)

Determines which users can see a report based on permission group codes.

Leave blank to make report available to all users.

Multidimensional pipe delimited valueMethod which allows entry of multiple values in a field. Values are separated by the pipe character -- | In addition a leading, or starting, and trailing, or ending pipe is required. For example the string |A|B|C|D| provides the values A, B, C and D to the system., with leading and trailing pipes.

Enter valid permission group codes separated by pipes.